CREATE TABLE "iws_inventory_task"
(
    "id"                 VARCHAR(50) PRIMARY KEY,
    "task_id"            VARCHAR(50) NULL DEFAULT NULL,
    "task_status"        INT         NULL DEFAULT NULL,
    "inventory_type"     VARCHAR(50) NULL DEFAULT NULL,
    "container_code"     VARCHAR(50) NULL DEFAULT NULL,
    "container_status"   INT         NULL DEFAULT NULL,
    "item_bar_code"      VARCHAR(50) NULL DEFAULT NULL,
    "material_code"      VARCHAR(50) NULL DEFAULT NULL,
    "material_name"      VARCHAR(50) NULL DEFAULT NULL,
    "entry_time"     DATETIME    NULL DEFAULT NULL,
    "inventory_quantity" FLOAT       NULL DEFAULT NULL,
    "task_start"         VARCHAR(50) NULL DEFAULT NULL,
    "task_end"           VARCHAR(50) NULL DEFAULT NULL,
    "work_ip"            VARCHAR(50) NULL DEFAULT NULL,
    "floor"              VARCHAR(50) NULL DEFAULT NULL,
    "good_type"          VARCHAR(50) NULL DEFAULT NULL,
    "create_name"        VARCHAR(50) NULL DEFAULT NULL,
    "create_date"        DATETIME    NULL DEFAULT NULL,
    "start_name"        VARCHAR(50) NULL DEFAULT NULL,
    "start_date"         DATETIME    NULL DEFAULT NULL,
);
exec sp_addextendedproperty 'MS_Description', N'任务单号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'id'
go
exec sp_addextendedproperty 'MS_Description', N'任务状态', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'task_status'
go
exec sp_addextendedproperty 'MS_Description', N'盘点类型（全盘，抽盘，动碰盘）', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'inventory_type'
go
exec sp_addextendedproperty 'MS_Description', N'任务起点储位', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'task_start'
go
exec sp_addextendedproperty 'MS_Description', N'任务终点储位', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'task_end'
go
exec sp_addextendedproperty 'MS_Description', N'载具状态', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'container_status'
go
exec sp_addextendedproperty 'MS_Description', N'载具码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'container_code'
go
exec sp_addextendedproperty 'MS_Description', N'物料条码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'item_bar_code'
go
exec sp_addextendedproperty 'MS_Description', N'物料编码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'material_code'
go
exec sp_addextendedproperty 'MS_Description', N'物料名字', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'material_name'
go
exec sp_addextendedproperty 'MS_Description', N'入厂时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'entry_time'
go
exec sp_addextendedproperty 'MS_Description', N'物料数量', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'inventory_quantity'
go
exec sp_addextendedproperty 'MS_Description', N'仓库', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'floor'
go
exec sp_addextendedproperty 'MS_Description', N'工位IP', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'work_ip'
go
exec sp_addextendedproperty 'MS_Description', N'货位类型', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'good_type'
go
exec sp_addextendedproperty 'MS_Description', N'建单账号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'create_name'
go
exec sp_addextendedproperty 'MS_Description', N'建单时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'create_date'
go
exec sp_addextendedproperty 'MS_Description', N'盘点账号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'start_name'
go
exec sp_addextendedproperty 'MS_Description', N'开始时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_inventory_task', 'COLUMN', 'start_date'
go

